1400/04/08 |

ایجاد categories در update-database migration

استاد سلام

من وقتی داشتم categories رو مایگریشن میزدم وقتی از دستور update-database استفاده می کنم این خطا رو ارسال میکنه:

Failed executing DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE TABLE [Categories] (
    [Id] bigint NOT NULL IDENTITY,
    [Name] nvarchar(max) NULL,
    [ParentCategoryId] bigint NOT NULL,
    [InsertTime] datetime2 NOT NULL,
    [UpdateTime] datetime2 NULL,
    [IsRemoved] bit NOT NULL,
    [RemoveTime] datetime2 NULL,
    CONSTRAINT [PK_Categories] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_Categories_Categories_ParentcategoryId] FOREIGN KEY ([ParentCategoryId]) REFERENCES [Categories] ([Id]) ON DELETE CASCADE

 

 

 

Introducing FOREIGN KEY constraint 'FK_Categories_Categories_ParentcategoryId' on table 'Categories' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint or index. See previous errors.